publish web service for storing information in PostgreSQL DB following XSD Resource

09 Jun '14, 10:24 AM

64,122 Views

Adrian Cendran Segura

No Forum Badges

Hello,

I have a problem when I try to store a series of data in my database through the use of a web service which I published on my project.

In this web project I created an XSD Resource Provider with its XSD Resource which I want to use to format the data collection web service and store it properly in a database created with PostgreSQL. This data base is related to several entities and relationships within the Domain Model

The case is that I don’t know which units within the web service I have to use, or how to relate them to perform the save information.

I have seen an example in the documentation WebRatio

http://www.webratio.com/learn/learningobject/XML-Schema-Definition-Support?link=oln2ae.redirect&nav=16&cbck=wrReq14462#toc5

Which synchronizes the XSD and creates a Domain Model to work with.

In my case the Domain Model is already created and I want to use it to store information following the guidance of my XSD

I would really appreciate your help

x 0

1 Answers

12 Jun '14, 03:13 PM

Ombretta Malinverno

Forum Expert - Level 5

Hi Adrian,

to save the data in a persistent database, retrieved from a web service based on an XSD you need to lean volatile entity based on your XSD as explained in the article http://www.webratio.com/learn/learningobject/XML Scheme-Definition-Support, because the persistent entities can not be associated with it, and then save the data automatically.

When creating a Web service you must always have in addition to the "Error Response", also the "Response" Operation which is the output of the response of the web service when its operations are completed successfully as you can see from the examples in this article http://www.webratio.com/learn/learningobject/Getting-started-with-Web-Services

The logic that you should follow in order to solve your problem is:

- Create the entity volatile based on XSD

- On solicit the input is set as a parameter based sull'XSD, ie attach the XSD Provider and the relative XSD Type.

- Use the "XML I / O" component instead of "XML In". By setting the "Mode" to "Import" and associate this entity volatile component based sull'xsd.

- To save the data to the database, once you've saved on the extent volatile data received from the web service you read the data just loaded in the volatile entity and save in the persisten entity.

Let me know if the information you have been helpful.

Best regards,

Ombretta malinverno

x 1

Related questions

502 proxy error-generate and run Access wsdl in https Adding and deleting from the database Agregar boton de cambio de contraseña en el login Alimentar graficas con base de datos Atributos Condicionales heredados Attribute comparison in a selector unit [beginner] - How to store and browse data collected with BPM app? Business object data Cancellare campi e tabelle dal database Cannot add a Database in the Domain Model Cannot connect to MySQL Can not get generate and run option for DataService Project Cannot insert an entity in the database Cannot invoke method selectSingleNode() on null object Can't generate and run database or start tomcat server! CelsiusToFahrenheit Example Change uplod directory and protect anauthorized access to files Como mostrar una imagen en una lista o en la componente detalles? Como recuperar todos los atributos de una relacion N:N y insertar registros? com.webratio.rtx.RTXException: An error occurred dispatching the SOAP message Conexion a Oracle 12g Connection refused. connect to Cloud Convert data in a Calculated attribute Convert selector component result to single value Could not create service Creación DB Apache Derby - Modelado BPMN Criptare dati sensibili nel database Custom Unit and AJAX / SOAP Database connection, Host and Port number Database password encrypting Database properties Database resource consumption Database Tables Creation After Remote Deploy DB in Data Service Project Deploy in Cloud Amazon Beanstalk with Postgres Description: Unknown tag 'wr:LinkResource' Dynamic data type Empty record mistakenly saved Error updating metadata process EverLasting error "The TCP/IP connection to the host has failed. Connection refused" Exception REST Post request Execute truncate sql query Exposing SOAP Web SERVICE on port different from 80 file analysis then update MySQL database Find Model Problemas Foriegn key relationship Generate and run locally on webratio professional edition. Generation options problem getting data from database Getting started with Web Services Groovy and Database Guardar Saltos de LINEA Hide a form if condition if true How can I import a view in the Domain Model as an attribute of an Entity? How can I invoke a Rest Web Service having dynamic parameters? How database or datamodel migration? How I can receive the primary key value after adding into database from OK Port. How to block empty string in Database How to change smtp port How to disble derby database? How to fix Network error(status 0) How to run web app with authentication service How to show certain values derived from relations in the domain model? I can't run any application with WebRatio (Table/View 'APP.POST' does not exist) Image in List field Insert data into database invoke rest web service that returns a pdf invoking a webservice using REST Is it possible to create a derived relationship between databases? java.lang.NullPointerException JDBC4 Postgresql Driver JDBC connection with mysql on mac Job not start correctly Mapping database of the entity '...' is unspecified [MOBILE] Can't synchronize domain model with beck end DB Mostrar datos de diferentes tablas/ show dates from diferentes entities MS SQL server jdbc file multi selections field problem MySQL Driver jdbc No Apache Derby driver found No cloud accounts available No Database on Cloud account No database on my cloud account Parameters order in a webservice request Passing JSON Object to Model Personalizzare lo stile di un progetto PostgreSQL Predefined values in database Problem accessing MySQL with WebRatio 6 Problema generando la logica de un proyecto Problema Grafo da una lista gerarchica Problema ¨HTTP Status 404" Problemas al invocar webservice Problemas con el Operations View Delete Problem saving multi selection from input Problems to connect Sql Server DB from Webratio Problems with Database Metadata Problem with fields with accents used in attribute condition Problem with query unit! Problem with stored procedure Problem with the deletion of more than 50.000 records in a table Properties of the XSD Resource (File) Publish a web service query a database Refresh and Synchronize DB Problems Relaciones Removing the User-Group-Module tagles Retrieve a value and add some value to it reverse engineering, problema con le relazioni di default Script Unit e Mysql Share database connection Solve "Generation Error" with Generate and Run option Statistics Component for WebRatio > 7.2.0 Status ProcessInstance and activityInstance in spanish Sybase JConnect 4 JAR replace Sync DataService Project with Mobile Project Table 'freeapp43.profesion' doesn't exist Tarea de servicio no me evalua el valor Trying to Synchronize Domain Model Unable to execute the script java.lang.NullPointerException Unknow property on Dynaclass after generation Unspecified BPM Engine Database Update mutiple records with the same value upload file and the move it to other location User Login Timestamp Username come chiave Using own User and Group tables usuarios y grupos WebRatio and MySQL Web ratio data model WebRatio - list results of joined tables Web Ratio Mobile and Foreign Key WebRatio Mobile Platform Community edition - Restful request Web Ratio Mobile - Remote data mapping problem WebRatio no imports all attributes (fields) of a table WebService DateTime value is not parsed to Date. Web service provider newline problem web service request using XSD Web service - Synchronize XSD When stars web ratio between dofollow and nofollow backlink has affected? When using web services, what kind authentication is used? Where is the ACME demo data stored?! which of these three models is closer to webratio/ifml way of creating web applications White report XML Out Unit and Soap Request Response Unit XML Schema Definition Support XML Schema Definition Support